﻿CREATE PROCEDURE [dbo].[proc_Company_Range_GetItem]
	(
		@TId uniqueidentifier
	)
AS
	Select
	R.Id,
	R.TId,
	R.UserName,
	R.EName,
	R.CompanyId,
	ISNULL((Select CompanyName From Company Where Id=R.CompanyId),'...') As CompanyName,
	R.UpName,
	R.[UpDate]
	From Company_RangeUsers R Where R.TId=@TId
	RETURN
